create table qrtz_locks
(
    sched_name nvarchar(120) not null,
    lock_name  nvarchar(40)  not null,
    primary key (sched_name, lock_name)
)
go

exec sp_addextendedproperty 'MS_Description', '存储的悲观锁信息表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_locks'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_locks', 'COLUMN', 'sched_name'
go

exec sp_addextendedproperty 'MS_Description', '悲观锁名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_locks', 'COLUMN', 'lock_name'
go

INSERT INTO [ry-vue].dbo.qrtz_locks (sched_name, lock_name) VALUES (N'RuoyiScheduler', N'STATE_ACCESS');
INSERT INTO [ry-vue].dbo.qrtz_locks (sched_name, lock_name) VALUES (N'RuoyiScheduler', N'TRIGGER_ACCESS');